package cn.iinda.electronicInfo.model;

import java.util.ArrayList;
import java.util.List;

public class DicomdataViewExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public DicomdataViewExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andStudyinfoidIsNull() {
            addCriterion("StudyInfoID is null");
            return (Criteria) this;
        }

        public Criteria andStudyinfoidIsNotNull() {
            addCriterion("StudyInfoID is not null");
            return (Criteria) this;
        }

        public Criteria andStudyinfoidEqualTo(Integer value) {
            addCriterion("StudyInfoID =", value, "studyinfoid");
            return (Criteria) this;
        }

        public Criteria andStudyinfoidNotEqualTo(Integer value) {
            addCriterion("StudyInfoID <>", value, "studyinfoid");
            return (Criteria) this;
        }

        public Criteria andStudyinfoidGreaterThan(Integer value) {
            addCriterion("StudyInfoID >", value, "studyinfoid");
            return (Criteria) this;
        }

        public Criteria andStudyinfoidGreaterThanOrEqualTo(Integer value) {
            addCriterion("StudyInfoID >=", value, "studyinfoid");
            return (Criteria) this;
        }

        public Criteria andStudyinfoidLessThan(Integer value) {
            addCriterion("StudyInfoID <", value, "studyinfoid");
            return (Criteria) this;
        }

        public Criteria andStudyinfoidLessThanOrEqualTo(Integer value) {
            addCriterion("StudyInfoID <=", value, "studyinfoid");
            return (Criteria) this;
        }

        public Criteria andStudyinfoidIn(List<Integer> values) {
            addCriterion("StudyInfoID in", values, "studyinfoid");
            return (Criteria) this;
        }

        public Criteria andStudyinfoidNotIn(List<Integer> values) {
            addCriterion("StudyInfoID not in", values, "studyinfoid");
            return (Criteria) this;
        }

        public Criteria andStudyinfoidBetween(Integer value1, Integer value2) {
            addCriterion("StudyInfoID between", value1, value2, "studyinfoid");
            return (Criteria) this;
        }

        public Criteria andStudyinfoidNotBetween(Integer value1, Integer value2) {
            addCriterion("StudyInfoID not between", value1, value2, "studyinfoid");
            return (Criteria) this;
        }

        public Criteria andCzipIsNull() {
            addCriterion("CZIP is null");
            return (Criteria) this;
        }

        public Criteria andCzipIsNotNull() {
            addCriterion("CZIP is not null");
            return (Criteria) this;
        }

        public Criteria andCzipEqualTo(String value) {
            addCriterion("CZIP =", value, "czip");
            return (Criteria) this;
        }

        public Criteria andCzipNotEqualTo(String value) {
            addCriterion("CZIP <>", value, "czip");
            return (Criteria) this;
        }

        public Criteria andCzipGreaterThan(String value) {
            addCriterion("CZIP >", value, "czip");
            return (Criteria) this;
        }

        public Criteria andCzipGreaterThanOrEqualTo(String value) {
            addCriterion("CZIP >=", value, "czip");
            return (Criteria) this;
        }

        public Criteria andCzipLessThan(String value) {
            addCriterion("CZIP <", value, "czip");
            return (Criteria) this;
        }

        public Criteria andCzipLessThanOrEqualTo(String value) {
            addCriterion("CZIP <=", value, "czip");
            return (Criteria) this;
        }

        public Criteria andCzipLike(String value) {
            addCriterion("CZIP like", value, "czip");
            return (Criteria) this;
        }

        public Criteria andCzipNotLike(String value) {
            addCriterion("CZIP not like", value, "czip");
            return (Criteria) this;
        }

        public Criteria andCzipIn(List<String> values) {
            addCriterion("CZIP in", values, "czip");
            return (Criteria) this;
        }

        public Criteria andCzipNotIn(List<String> values) {
            addCriterion("CZIP not in", values, "czip");
            return (Criteria) this;
        }

        public Criteria andCzipBetween(String value1, String value2) {
            addCriterion("CZIP between", value1, value2, "czip");
            return (Criteria) this;
        }

        public Criteria andCzipNotBetween(String value1, String value2) {
            addCriterion("CZIP not between", value1, value2, "czip");
            return (Criteria) this;
        }

        public Criteria andJpgIsNull() {
            addCriterion("Jpg is null");
            return (Criteria) this;
        }

        public Criteria andJpgIsNotNull() {
            addCriterion("Jpg is not null");
            return (Criteria) this;
        }

        public Criteria andJpgEqualTo(String value) {
            addCriterion("Jpg =", value, "jpg");
            return (Criteria) this;
        }

        public Criteria andJpgNotEqualTo(String value) {
            addCriterion("Jpg <>", value, "jpg");
            return (Criteria) this;
        }

        public Criteria andJpgGreaterThan(String value) {
            addCriterion("Jpg >", value, "jpg");
            return (Criteria) this;
        }

        public Criteria andJpgGreaterThanOrEqualTo(String value) {
            addCriterion("Jpg >=", value, "jpg");
            return (Criteria) this;
        }

        public Criteria andJpgLessThan(String value) {
            addCriterion("Jpg <", value, "jpg");
            return (Criteria) this;
        }

        public Criteria andJpgLessThanOrEqualTo(String value) {
            addCriterion("Jpg <=", value, "jpg");
            return (Criteria) this;
        }

        public Criteria andJpgLike(String value) {
            addCriterion("Jpg like", value, "jpg");
            return (Criteria) this;
        }

        public Criteria andJpgNotLike(String value) {
            addCriterion("Jpg not like", value, "jpg");
            return (Criteria) this;
        }

        public Criteria andJpgIn(List<String> values) {
            addCriterion("Jpg in", values, "jpg");
            return (Criteria) this;
        }

        public Criteria andJpgNotIn(List<String> values) {
            addCriterion("Jpg not in", values, "jpg");
            return (Criteria) this;
        }

        public Criteria andJpgBetween(String value1, String value2) {
            addCriterion("Jpg between", value1, value2, "jpg");
            return (Criteria) this;
        }

        public Criteria andJpgNotBetween(String value1, String value2) {
            addCriterion("Jpg not between", value1, value2, "jpg");
            return (Criteria) this;
        }

        public Criteria andCimageidIsNull() {
            addCriterion("CImageID is null");
            return (Criteria) this;
        }

        public Criteria andCimageidIsNotNull() {
            addCriterion("CImageID is not null");
            return (Criteria) this;
        }

        public Criteria andCimageidEqualTo(String value) {
            addCriterion("CImageID =", value, "cimageid");
            return (Criteria) this;
        }

        public Criteria andCimageidNotEqualTo(String value) {
            addCriterion("CImageID <>", value, "cimageid");
            return (Criteria) this;
        }

        public Criteria andCimageidGreaterThan(String value) {
            addCriterion("CImageID >", value, "cimageid");
            return (Criteria) this;
        }

        public Criteria andCimageidGreaterThanOrEqualTo(String value) {
            addCriterion("CImageID >=", value, "cimageid");
            return (Criteria) this;
        }

        public Criteria andCimageidLessThan(String value) {
            addCriterion("CImageID <", value, "cimageid");
            return (Criteria) this;
        }

        public Criteria andCimageidLessThanOrEqualTo(String value) {
            addCriterion("CImageID <=", value, "cimageid");
            return (Criteria) this;
        }

        public Criteria andCimageidLike(String value) {
            addCriterion("CImageID like", value, "cimageid");
            return (Criteria) this;
        }

        public Criteria andCimageidNotLike(String value) {
            addCriterion("CImageID not like", value, "cimageid");
            return (Criteria) this;
        }

        public Criteria andCimageidIn(List<String> values) {
            addCriterion("CImageID in", values, "cimageid");
            return (Criteria) this;
        }

        public Criteria andCimageidNotIn(List<String> values) {
            addCriterion("CImageID not in", values, "cimageid");
            return (Criteria) this;
        }

        public Criteria andCimageidBetween(String value1, String value2) {
            addCriterion("CImageID between", value1, value2, "cimageid");
            return (Criteria) this;
        }

        public Criteria andCimageidNotBetween(String value1, String value2) {
            addCriterion("CImageID not between", value1, value2, "cimageid");
            return (Criteria) this;
        }

        public Criteria andCmd5IsNull() {
            addCriterion("CMD5 is null");
            return (Criteria) this;
        }

        public Criteria andCmd5IsNotNull() {
            addCriterion("CMD5 is not null");
            return (Criteria) this;
        }

        public Criteria andCmd5EqualTo(String value) {
            addCriterion("CMD5 =", value, "cmd5");
            return (Criteria) this;
        }

        public Criteria andCmd5NotEqualTo(String value) {
            addCriterion("CMD5 <>", value, "cmd5");
            return (Criteria) this;
        }

        public Criteria andCmd5GreaterThan(String value) {
            addCriterion("CMD5 >", value, "cmd5");
            return (Criteria) this;
        }

        public Criteria andCmd5GreaterThanOrEqualTo(String value) {
            addCriterion("CMD5 >=", value, "cmd5");
            return (Criteria) this;
        }

        public Criteria andCmd5LessThan(String value) {
            addCriterion("CMD5 <", value, "cmd5");
            return (Criteria) this;
        }

        public Criteria andCmd5LessThanOrEqualTo(String value) {
            addCriterion("CMD5 <=", value, "cmd5");
            return (Criteria) this;
        }

        public Criteria andCmd5Like(String value) {
            addCriterion("CMD5 like", value, "cmd5");
            return (Criteria) this;
        }

        public Criteria andCmd5NotLike(String value) {
            addCriterion("CMD5 not like", value, "cmd5");
            return (Criteria) this;
        }

        public Criteria andCmd5In(List<String> values) {
            addCriterion("CMD5 in", values, "cmd5");
            return (Criteria) this;
        }

        public Criteria andCmd5NotIn(List<String> values) {
            addCriterion("CMD5 not in", values, "cmd5");
            return (Criteria) this;
        }

        public Criteria andCmd5Between(String value1, String value2) {
            addCriterion("CMD5 between", value1, value2, "cmd5");
            return (Criteria) this;
        }

        public Criteria andCmd5NotBetween(String value1, String value2) {
            addCriterion("CMD5 not between", value1, value2, "cmd5");
            return (Criteria) this;
        }

        public Criteria andCmodalityIsNull() {
            addCriterion("CModality is null");
            return (Criteria) this;
        }

        public Criteria andCmodalityIsNotNull() {
            addCriterion("CModality is not null");
            return (Criteria) this;
        }

        public Criteria andCmodalityEqualTo(String value) {
            addCriterion("CModality =", value, "cmodality");
            return (Criteria) this;
        }

        public Criteria andCmodalityNotEqualTo(String value) {
            addCriterion("CModality <>", value, "cmodality");
            return (Criteria) this;
        }

        public Criteria andCmodalityGreaterThan(String value) {
            addCriterion("CModality >", value, "cmodality");
            return (Criteria) this;
        }

        public Criteria andCmodalityGreaterThanOrEqualTo(String value) {
            addCriterion("CModality >=", value, "cmodality");
            return (Criteria) this;
        }

        public Criteria andCmodalityLessThan(String value) {
            addCriterion("CModality <", value, "cmodality");
            return (Criteria) this;
        }

        public Criteria andCmodalityLessThanOrEqualTo(String value) {
            addCriterion("CModality <=", value, "cmodality");
            return (Criteria) this;
        }

        public Criteria andCmodalityLike(String value) {
            addCriterion("CModality like", value, "cmodality");
            return (Criteria) this;
        }

        public Criteria andCmodalityNotLike(String value) {
            addCriterion("CModality not like", value, "cmodality");
            return (Criteria) this;
        }

        public Criteria andCmodalityIn(List<String> values) {
            addCriterion("CModality in", values, "cmodality");
            return (Criteria) this;
        }

        public Criteria andCmodalityNotIn(List<String> values) {
            addCriterion("CModality not in", values, "cmodality");
            return (Criteria) this;
        }

        public Criteria andCmodalityBetween(String value1, String value2) {
            addCriterion("CModality between", value1, value2, "cmodality");
            return (Criteria) this;
        }

        public Criteria andCmodalityNotBetween(String value1, String value2) {
            addCriterion("CModality not between", value1, value2, "cmodality");
            return (Criteria) this;
        }

        public Criteria andTreIsNull() {
            addCriterion("tre is null");
            return (Criteria) this;
        }

        public Criteria andTreIsNotNull() {
            addCriterion("tre is not null");
            return (Criteria) this;
        }

        public Criteria andTreEqualTo(String value) {
            addCriterion("tre =", value, "tre");
            return (Criteria) this;
        }

        public Criteria andTreNotEqualTo(String value) {
            addCriterion("tre <>", value, "tre");
            return (Criteria) this;
        }

        public Criteria andTreGreaterThan(String value) {
            addCriterion("tre >", value, "tre");
            return (Criteria) this;
        }

        public Criteria andTreGreaterThanOrEqualTo(String value) {
            addCriterion("tre >=", value, "tre");
            return (Criteria) this;
        }

        public Criteria andTreLessThan(String value) {
            addCriterion("tre <", value, "tre");
            return (Criteria) this;
        }

        public Criteria andTreLessThanOrEqualTo(String value) {
            addCriterion("tre <=", value, "tre");
            return (Criteria) this;
        }

        public Criteria andTreLike(String value) {
            addCriterion("tre like", value, "tre");
            return (Criteria) this;
        }

        public Criteria andTreNotLike(String value) {
            addCriterion("tre not like", value, "tre");
            return (Criteria) this;
        }

        public Criteria andTreIn(List<String> values) {
            addCriterion("tre in", values, "tre");
            return (Criteria) this;
        }

        public Criteria andTreNotIn(List<String> values) {
            addCriterion("tre not in", values, "tre");
            return (Criteria) this;
        }

        public Criteria andTreBetween(String value1, String value2) {
            addCriterion("tre between", value1, value2, "tre");
            return (Criteria) this;
        }

        public Criteria andTreNotBetween(String value1, String value2) {
            addCriterion("tre not between", value1, value2, "tre");
            return (Criteria) this;
        }

        public Criteria andAgeIsNull() {
            addCriterion("age is null");
            return (Criteria) this;
        }

        public Criteria andAgeIsNotNull() {
            addCriterion("age is not null");
            return (Criteria) this;
        }

        public Criteria andAgeEqualTo(String value) {
            addCriterion("age =", value, "age");
            return (Criteria) this;
        }

        public Criteria andAgeNotEqualTo(String value) {
            addCriterion("age <>", value, "age");
            return (Criteria) this;
        }

        public Criteria andAgeGreaterThan(String value) {
            addCriterion("age >", value, "age");
            return (Criteria) this;
        }

        public Criteria andAgeGreaterThanOrEqualTo(String value) {
            addCriterion("age >=", value, "age");
            return (Criteria) this;
        }

        public Criteria andAgeLessThan(String value) {
            addCriterion("age <", value, "age");
            return (Criteria) this;
        }

        public Criteria andAgeLessThanOrEqualTo(String value) {
            addCriterion("age <=", value, "age");
            return (Criteria) this;
        }

        public Criteria andAgeLike(String value) {
            addCriterion("age like", value, "age");
            return (Criteria) this;
        }

        public Criteria andAgeNotLike(String value) {
            addCriterion("age not like", value, "age");
            return (Criteria) this;
        }

        public Criteria andAgeIn(List<String> values) {
            addCriterion("age in", values, "age");
            return (Criteria) this;
        }

        public Criteria andAgeNotIn(List<String> values) {
            addCriterion("age not in", values, "age");
            return (Criteria) this;
        }

        public Criteria andAgeBetween(String value1, String value2) {
            addCriterion("age between", value1, value2, "age");
            return (Criteria) this;
        }

        public Criteria andAgeNotBetween(String value1, String value2) {
            addCriterion("age not between", value1, value2, "age");
            return (Criteria) this;
        }

        public Criteria andChosIsNull() {
            addCriterion("CHos is null");
            return (Criteria) this;
        }

        public Criteria andChosIsNotNull() {
            addCriterion("CHos is not null");
            return (Criteria) this;
        }

        public Criteria andChosEqualTo(String value) {
            addCriterion("CHos =", value, "chos");
            return (Criteria) this;
        }

        public Criteria andChosNotEqualTo(String value) {
            addCriterion("CHos <>", value, "chos");
            return (Criteria) this;
        }

        public Criteria andChosGreaterThan(String value) {
            addCriterion("CHos >", value, "chos");
            return (Criteria) this;
        }

        public Criteria andChosGreaterThanOrEqualTo(String value) {
            addCriterion("CHos >=", value, "chos");
            return (Criteria) this;
        }

        public Criteria andChosLessThan(String value) {
            addCriterion("CHos <", value, "chos");
            return (Criteria) this;
        }

        public Criteria andChosLessThanOrEqualTo(String value) {
            addCriterion("CHos <=", value, "chos");
            return (Criteria) this;
        }

        public Criteria andChosLike(String value) {
            addCriterion("CHos like", value, "chos");
            return (Criteria) this;
        }

        public Criteria andChosNotLike(String value) {
            addCriterion("CHos not like", value, "chos");
            return (Criteria) this;
        }

        public Criteria andChosIn(List<String> values) {
            addCriterion("CHos in", values, "chos");
            return (Criteria) this;
        }

        public Criteria andChosNotIn(List<String> values) {
            addCriterion("CHos not in", values, "chos");
            return (Criteria) this;
        }

        public Criteria andChosBetween(String value1, String value2) {
            addCriterion("CHos between", value1, value2, "chos");
            return (Criteria) this;
        }

        public Criteria andChosNotBetween(String value1, String value2) {
            addCriterion("CHos not between", value1, value2, "chos");
            return (Criteria) this;
        }

        public Criteria andCdesIsNull() {
            addCriterion("CDes is null");
            return (Criteria) this;
        }

        public Criteria andCdesIsNotNull() {
            addCriterion("CDes is not null");
            return (Criteria) this;
        }

        public Criteria andCdesEqualTo(String value) {
            addCriterion("CDes =", value, "cdes");
            return (Criteria) this;
        }

        public Criteria andCdesNotEqualTo(String value) {
            addCriterion("CDes <>", value, "cdes");
            return (Criteria) this;
        }

        public Criteria andCdesGreaterThan(String value) {
            addCriterion("CDes >", value, "cdes");
            return (Criteria) this;
        }

        public Criteria andCdesGreaterThanOrEqualTo(String value) {
            addCriterion("CDes >=", value, "cdes");
            return (Criteria) this;
        }

        public Criteria andCdesLessThan(String value) {
            addCriterion("CDes <", value, "cdes");
            return (Criteria) this;
        }

        public Criteria andCdesLessThanOrEqualTo(String value) {
            addCriterion("CDes <=", value, "cdes");
            return (Criteria) this;
        }

        public Criteria andCdesLike(String value) {
            addCriterion("CDes like", value, "cdes");
            return (Criteria) this;
        }

        public Criteria andCdesNotLike(String value) {
            addCriterion("CDes not like", value, "cdes");
            return (Criteria) this;
        }

        public Criteria andCdesIn(List<String> values) {
            addCriterion("CDes in", values, "cdes");
            return (Criteria) this;
        }

        public Criteria andCdesNotIn(List<String> values) {
            addCriterion("CDes not in", values, "cdes");
            return (Criteria) this;
        }

        public Criteria andCdesBetween(String value1, String value2) {
            addCriterion("CDes between", value1, value2, "cdes");
            return (Criteria) this;
        }

        public Criteria andCdesNotBetween(String value1, String value2) {
            addCriterion("CDes not between", value1, value2, "cdes");
            return (Criteria) this;
        }

        public Criteria andCpnameIsNull() {
            addCriterion("CPName is null");
            return (Criteria) this;
        }

        public Criteria andCpnameIsNotNull() {
            addCriterion("CPName is not null");
            return (Criteria) this;
        }

        public Criteria andCpnameEqualTo(String value) {
            addCriterion("CPName =", value, "cpname");
            return (Criteria) this;
        }

        public Criteria andCpnameNotEqualTo(String value) {
            addCriterion("CPName <>", value, "cpname");
            return (Criteria) this;
        }

        public Criteria andCpnameGreaterThan(String value) {
            addCriterion("CPName >", value, "cpname");
            return (Criteria) this;
        }

        public Criteria andCpnameGreaterThanOrEqualTo(String value) {
            addCriterion("CPName >=", value, "cpname");
            return (Criteria) this;
        }

        public Criteria andCpnameLessThan(String value) {
            addCriterion("CPName <", value, "cpname");
            return (Criteria) this;
        }

        public Criteria andCpnameLessThanOrEqualTo(String value) {
            addCriterion("CPName <=", value, "cpname");
            return (Criteria) this;
        }

        public Criteria andCpnameLike(String value) {
            addCriterion("CPName like", value, "cpname");
            return (Criteria) this;
        }

        public Criteria andCpnameNotLike(String value) {
            addCriterion("CPName not like", value, "cpname");
            return (Criteria) this;
        }

        public Criteria andCpnameIn(List<String> values) {
            addCriterion("CPName in", values, "cpname");
            return (Criteria) this;
        }

        public Criteria andCpnameNotIn(List<String> values) {
            addCriterion("CPName not in", values, "cpname");
            return (Criteria) this;
        }

        public Criteria andCpnameBetween(String value1, String value2) {
            addCriterion("CPName between", value1, value2, "cpname");
            return (Criteria) this;
        }

        public Criteria andCpnameNotBetween(String value1, String value2) {
            addCriterion("CPName not between", value1, value2, "cpname");
            return (Criteria) this;
        }

        public Criteria andCsexIsNull() {
            addCriterion("CSex is null");
            return (Criteria) this;
        }

        public Criteria andCsexIsNotNull() {
            addCriterion("CSex is not null");
            return (Criteria) this;
        }

        public Criteria andCsexEqualTo(String value) {
            addCriterion("CSex =", value, "csex");
            return (Criteria) this;
        }

        public Criteria andCsexNotEqualTo(String value) {
            addCriterion("CSex <>", value, "csex");
            return (Criteria) this;
        }

        public Criteria andCsexGreaterThan(String value) {
            addCriterion("CSex >", value, "csex");
            return (Criteria) this;
        }

        public Criteria andCsexGreaterThanOrEqualTo(String value) {
            addCriterion("CSex >=", value, "csex");
            return (Criteria) this;
        }

        public Criteria andCsexLessThan(String value) {
            addCriterion("CSex <", value, "csex");
            return (Criteria) this;
        }

        public Criteria andCsexLessThanOrEqualTo(String value) {
            addCriterion("CSex <=", value, "csex");
            return (Criteria) this;
        }

        public Criteria andCsexLike(String value) {
            addCriterion("CSex like", value, "csex");
            return (Criteria) this;
        }

        public Criteria andCsexNotLike(String value) {
            addCriterion("CSex not like", value, "csex");
            return (Criteria) this;
        }

        public Criteria andCsexIn(List<String> values) {
            addCriterion("CSex in", values, "csex");
            return (Criteria) this;
        }

        public Criteria andCsexNotIn(List<String> values) {
            addCriterion("CSex not in", values, "csex");
            return (Criteria) this;
        }

        public Criteria andCsexBetween(String value1, String value2) {
            addCriterion("CSex between", value1, value2, "csex");
            return (Criteria) this;
        }

        public Criteria andCsexNotBetween(String value1, String value2) {
            addCriterion("CSex not between", value1, value2, "csex");
            return (Criteria) this;
        }

        public Criteria andIidIsNull() {
            addCriterion("IID is null");
            return (Criteria) this;
        }

        public Criteria andIidIsNotNull() {
            addCriterion("IID is not null");
            return (Criteria) this;
        }

        public Criteria andIidEqualTo(Integer value) {
            addCriterion("IID =", value, "iid");
            return (Criteria) this;
        }

        public Criteria andIidNotEqualTo(Integer value) {
            addCriterion("IID <>", value, "iid");
            return (Criteria) this;
        }

        public Criteria andIidGreaterThan(Integer value) {
            addCriterion("IID >", value, "iid");
            return (Criteria) this;
        }

        public Criteria andIidGreaterThanOrEqualTo(Integer value) {
            addCriterion("IID >=", value, "iid");
            return (Criteria) this;
        }

        public Criteria andIidLessThan(Integer value) {
            addCriterion("IID <", value, "iid");
            return (Criteria) this;
        }

        public Criteria andIidLessThanOrEqualTo(Integer value) {
            addCriterion("IID <=", value, "iid");
            return (Criteria) this;
        }

        public Criteria andIidIn(List<Integer> values) {
            addCriterion("IID in", values, "iid");
            return (Criteria) this;
        }

        public Criteria andIidNotIn(List<Integer> values) {
            addCriterion("IID not in", values, "iid");
            return (Criteria) this;
        }

        public Criteria andIidBetween(Integer value1, Integer value2) {
            addCriterion("IID between", value1, value2, "iid");
            return (Criteria) this;
        }

        public Criteria andIidNotBetween(Integer value1, Integer value2) {
            addCriterion("IID not between", value1, value2, "iid");
            return (Criteria) this;
        }

        public Criteria andPidIsNull() {
            addCriterion("PID is null");
            return (Criteria) this;
        }

        public Criteria andPidIsNotNull() {
            addCriterion("PID is not null");
            return (Criteria) this;
        }

        public Criteria andPidEqualTo(Integer value) {
            addCriterion("PID =", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidNotEqualTo(Integer value) {
            addCriterion("PID <>", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidGreaterThan(Integer value) {
            addCriterion("PID >", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidGreaterThanOrEqualTo(Integer value) {
            addCriterion("PID >=", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidLessThan(Integer value) {
            addCriterion("PID <", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidLessThanOrEqualTo(Integer value) {
            addCriterion("PID <=", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidIn(List<Integer> values) {
            addCriterion("PID in", values, "pid");
            return (Criteria) this;
        }

        public Criteria andPidNotIn(List<Integer> values) {
            addCriterion("PID not in", values, "pid");
            return (Criteria) this;
        }

        public Criteria andPidBetween(Integer value1, Integer value2) {
            addCriterion("PID between", value1, value2, "pid");
            return (Criteria) this;
        }

        public Criteria andPidNotBetween(Integer value1, Integer value2) {
            addCriterion("PID not between", value1, value2, "pid");
            return (Criteria) this;
        }

        public Criteria andCseriesidIsNull() {
            addCriterion("CSeriesID is null");
            return (Criteria) this;
        }

        public Criteria andCseriesidIsNotNull() {
            addCriterion("CSeriesID is not null");
            return (Criteria) this;
        }

        public Criteria andCseriesidEqualTo(String value) {
            addCriterion("CSeriesID =", value, "cseriesid");
            return (Criteria) this;
        }

        public Criteria andCseriesidNotEqualTo(String value) {
            addCriterion("CSeriesID <>", value, "cseriesid");
            return (Criteria) this;
        }

        public Criteria andCseriesidGreaterThan(String value) {
            addCriterion("CSeriesID >", value, "cseriesid");
            return (Criteria) this;
        }

        public Criteria andCseriesidGreaterThanOrEqualTo(String value) {
            addCriterion("CSeriesID >=", value, "cseriesid");
            return (Criteria) this;
        }

        public Criteria andCseriesidLessThan(String value) {
            addCriterion("CSeriesID <", value, "cseriesid");
            return (Criteria) this;
        }

        public Criteria andCseriesidLessThanOrEqualTo(String value) {
            addCriterion("CSeriesID <=", value, "cseriesid");
            return (Criteria) this;
        }

        public Criteria andCseriesidLike(String value) {
            addCriterion("CSeriesID like", value, "cseriesid");
            return (Criteria) this;
        }

        public Criteria andCseriesidNotLike(String value) {
            addCriterion("CSeriesID not like", value, "cseriesid");
            return (Criteria) this;
        }

        public Criteria andCseriesidIn(List<String> values) {
            addCriterion("CSeriesID in", values, "cseriesid");
            return (Criteria) this;
        }

        public Criteria andCseriesidNotIn(List<String> values) {
            addCriterion("CSeriesID not in", values, "cseriesid");
            return (Criteria) this;
        }

        public Criteria andCseriesidBetween(String value1, String value2) {
            addCriterion("CSeriesID between", value1, value2, "cseriesid");
            return (Criteria) this;
        }

        public Criteria andCseriesidNotBetween(String value1, String value2) {
            addCriterion("CSeriesID not between", value1, value2, "cseriesid");
            return (Criteria) this;
        }

        public Criteria andCbzIsNull() {
            addCriterion("CBZ is null");
            return (Criteria) this;
        }

        public Criteria andCbzIsNotNull() {
            addCriterion("CBZ is not null");
            return (Criteria) this;
        }

        public Criteria andCbzEqualTo(String value) {
            addCriterion("CBZ =", value, "cbz");
            return (Criteria) this;
        }

        public Criteria andCbzNotEqualTo(String value) {
            addCriterion("CBZ <>", value, "cbz");
            return (Criteria) this;
        }

        public Criteria andCbzGreaterThan(String value) {
            addCriterion("CBZ >", value, "cbz");
            return (Criteria) this;
        }

        public Criteria andCbzGreaterThanOrEqualTo(String value) {
            addCriterion("CBZ >=", value, "cbz");
            return (Criteria) this;
        }

        public Criteria andCbzLessThan(String value) {
            addCriterion("CBZ <", value, "cbz");
            return (Criteria) this;
        }

        public Criteria andCbzLessThanOrEqualTo(String value) {
            addCriterion("CBZ <=", value, "cbz");
            return (Criteria) this;
        }

        public Criteria andCbzLike(String value) {
            addCriterion("CBZ like", value, "cbz");
            return (Criteria) this;
        }

        public Criteria andCbzNotLike(String value) {
            addCriterion("CBZ not like", value, "cbz");
            return (Criteria) this;
        }

        public Criteria andCbzIn(List<String> values) {
            addCriterion("CBZ in", values, "cbz");
            return (Criteria) this;
        }

        public Criteria andCbzNotIn(List<String> values) {
            addCriterion("CBZ not in", values, "cbz");
            return (Criteria) this;
        }

        public Criteria andCbzBetween(String value1, String value2) {
            addCriterion("CBZ between", value1, value2, "cbz");
            return (Criteria) this;
        }

        public Criteria andCbzNotBetween(String value1, String value2) {
            addCriterion("CBZ not between", value1, value2, "cbz");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}